--------------------------- ZIP 부분은 따로 관리하겠음 ------------------------
DROP TABLE ZIP;
DROP TABLE ZIPCODE;

CREATE TABLE ZIP(
            ZIPCODE varchar2(40),
            SIDO varchar2(46),
            GUGUN varchar2(40),
            DONG varchar2(40),
            RI varchar2(45),
            BLDG varchar2(80),
            BUNJI varchar2(30),
            SEQ varchar2(15)
            );

-- ZIP(우편검색용 진짜테이블 : ZIP로드작업 후 실행할 것) --
CREATE TABLE ZIPCODE(address,zipcode)
AS SELECT SIDO||' '||GUGUN||' '||DONG||' '||RI||' '||BLDG||' '||BUNJI, ZIPCODE
FROM ZIP;

-------------------------------------------------------------------------------




--- 여기부터시작입니다 ---

--------------------- FK 제약조건 모두 삭제 한 SQL문입니다 --------------------

 -- DROP Table, Sequence
 
DROP TABLE GRADE;
DROP TABLE MEMBER;
DROP TABLE CATEGORY;
DROP TABLE COMPANY;
DROP TABLE PRODUCT;
DROP TABLE CART;
DROP TABLE ORDERS;
DROP TABLE ORDERSDETAIL;
DROP TABLE BOARDTYPE;
DROP TABLE BOARD;
DROP TABLE BOARDREPLY;
DROP TABLE QNABOARD;
DROP TABLE QNABOARDREPLY;

DROP SEQUENCE GRADE_SEQ_NO;
DROP SEQUENCE MEMBER_SEQ_NO;
DROP SEQUENCE CATEGORY_SEQ_NO;
DROP SEQUENCE COMPANY_SEQ_NO;
DROP SEQUENCE PRODUCT_SEQ_NO;
DROP SEQUENCE CART_SEQ_NO;
DROP SEQUENCE ORDERS_SEQ_NO;
DROP SEQUENCE ORDERSDETAIL_SEQ_NO;
DROP SEQUENCE BOARDTYPE_SEQ_NO;
DROP SEQUENCE BOARD_SEQ_NO;
DROP SEQUENCE BOARDREPLY_SEQ_NO;
DROP SEQUENCE QNABOARD_SEQ_NO;
DROP SEQUENCE QNABOARDREPLY_SEQ_NO;



-- CREATE Table, Sequence

CREATE TABLE GRADE
(
    GRADE_NO NUMBER(10) NOT NULL PRIMARY KEY,
    GRADE_NAME VARCHAR2(10) NOT NULL
);

CREATE TABLE MEMBER
(
    MEMBER_NO NUMBER(10) NOT NULL PRIMARY KEY,
    MEMBER_ID VARCHAR2(20) NOT NULL,
    MEMBER_PASSWORD VARCHAR2(20) NOT NULL,
    MEMBER_NAME VARCHAR2(20) NOT NULL,
    MEMBER_BIRTH DATE NOT NULL,
    MEMBER_ZIP VARCHAR2(20) NOT NULL,
    MEMBER_ADDR1 VARCHAR2(100) NOT NULL,
    MEMBER_ADDR2 VARCHAR2(100) NOT NULL,
    MEMBER_PHONE VARCHAR2(20),
    MEMBER_EMAIL VARCHAR2(20),
    MEMBER_GRADE NUMBER(10) NOT NULL,
    MEMBER_NICKNAME VARCHAR2(20),     
    MEMBER_STATUS VARCHAR2(50)
);

CREATE TABLE CATEGORY
(
    CATEGORY_NO NUMBER(10) NOT NULL PRIMARY KEY,
    CATEGORY_NAME VARCHAR2(50) NOT NULL
);

CREATE TABLE COMPANY
(
    COMPANY_NO NUMBER(10) NOT NULL PRIMARY KEY,
    COMPANY_NAME VARCHAR2(50) NOT NULL
);

CREATE TABLE PRODUCT
(
    PRODUCT_NO NUMBER(10) NOT NULL PRIMARY KEY,
    PRODUCT_NAME VARCHAR2(100) NOT NULL,
    PRODUCT_PRICE NUMBER(10) NOT NULL,
    PRODUCT_CATEGORY NUMBER(10) NOT NULL,
    PRODUCT_COMPANY NUMBER(10) NOT NULL,
    PRODUCT_DETAIL VARCHAR2(500) NOT NULL,
    PRODUCT_COUNT NUMBER(10) NOT NULL,
    PRODUCT_IMAGE0 VARCHAR2(50),
    PRODUCT_IMAGE1 VARCHAR2(50),
    PRODUCT_IMAGE2 VARCHAR2(50),
    PRODUCT_IMAGE3 VARCHAR2(50),
    PRODUCT_IMAGE4 VARCHAR2(50),
    PRODUCT_IMAGE5 VARCHAR2(50),
    PRODUCT_IMAGE6 VARCHAR2(50),
    PRODUCT_IMAGE7 VARCHAR2(50),
    PRODUCT_IMAGE8 VARCHAR2(50),
    PRODUCT_IMAGE9 VARCHAR2(50)
);

CREATE TABLE CART
(
    CART_NO NUMBER(10) NOT NULL PRIMARY KEY,
    CART_MEMBER NUMBER(10) NOT NULL,
    CART_PRODUCT NUMBER(10) NOT NULL,
    CART_COUNT NUMBER(10) NOT NULL
);

CREATE TABLE ORDERS
(
    ORDERS_NO NUMBER(10) NOT NULL PRIMARY KEY,
    ORDERS_MEMBER NUMBER(10) NOT NULL,
    ORDERS_DATE DATE DEFAULT SYSDATE NOT NULL,
    ORDERS_NAME VARCHAR2(20) NOT NULL,
    ORDERS_EMAIL VARCHAR2(50) NOT NULL,
    ORDERS_PHONE VARCHAR2(20) NOT NULL,
    ORDERS_ZIP VARCHAR2(20) NOT NULL,
    ORDERS_ADDR1 VARCHAR2(100) NOT NULL,
    ORDERS_ADDR2 VARCHAR2(100) NOT NULL,
    ORDERS_PRICE VARCHAR2(20) NOT NULL,
    ORDERS_PAYMENTS VARCHAR2(50) NOT NULL,
    ORDERS_MSG VARCHAR2(100)
);

CREATE TABLE ORDERSDETAIL
(
    ODETAIL_NO NUMBER(10) NOT NULL PRIMARY KEY,
    ODETAIL_ORDERSNO NUMBER(10) NOT NULL,
    ODETAIL_PRODUCT NUMBER(10) NOT NULL,
    ODETAIL_COUNT NUMBER(10) NOT NULL
);

CREATE TABLE BOARDTYPE
(
    BTYPE_NO NUMBER(10) NOT NULL PRIMARY KEY,
    BTYPE_NAME VARCHAR2(50) NOT NULL
);

CREATE TABLE BOARD
(
    BOARD_NO NUMBER(10) NOT NULL PRIMARY KEY,
    BOARD_TYPE NUMBER(10) NOT NULL,
    BOARD_TITLE VARCHAR2(50) NOT NULL,
    BOARD_DATE DATE DEFAULT SYSDATE NOT NULL,
    BOARD_ID VARCHAR2(20) NOT NULL,
    BOARD_CONTENT VARCHAR2(1000) NOT NULL,
    BOARD_IMAGE VARCHAR2(50) NULL,
    BOARD_SHOW NUMBER(10) DEFAULT 0 NOT NULL,
    BOARD_RECOMMEND NUMBER(10) DEFAULT 0 NOT NULL,
    BOARD_NICKNAME VARCHAR2(20) NOT NULL
);
 
CREATE TABLE BOARDREPLY
(
    BREPLY_NO NUMBER(10) NOT NULL PRIMARY KEY,
    BREPLY_BOARDNO NUMBER(10) NOT NULL,
    BREPLY_DATE DATE DEFAULT SYSDATE NOT NULL,
    BREPLY_ID VARCHAR2(20) NOT NULL,
    BREPLY_RECOMMEND NUMBER(10) DEFAULT 0 NOT NULL,
	BREPLY_CONTENT VARCHAR(1000) NOT NULL
);

CREATE TABLE QNABOARD
(
    QNABOARD_NO NUMBER(10,0) NOT NULL PRIMARY KEY,
    QNABOARD_TITLE VARCHAR2(50) NOT NULL,
    QNABOARD_DATE DATE DEFAULT SYSDATE NOT NULL,
    QNABOARD_ID VARCHAR2(20) NOT NULL,
    QNABOARD_CONTENT VARCHAR2(1000) NOT NULL,
    QNABOARD_NICKNAME VARCHAR2(20) NOT NULL,
    QNABOARD_DEPTH NUMBER(10,0) NOT NULL,
    QNABOARD_GROUP NUMBER(10,0) NOT NULL
);

CREATE TABLE QNABOARDREPLY
(
    QNABOARD_REPLY_NO NUMBER(10,0) NOT NULL PRIMARY KEY,
    QNABOARD_REPLY_TITLE VARCHAR2(50) NOT NULL,
    QNABOARD_REPLY_DATE DATE DEFAULT SYSDATE NOT NULL,
    QNABOARD_REPLY_ID VARCHAR2(20) NOT NULL,
    QNABOARD_REPLY_CONTENT VARCHAR2(1000) NOT NULL,
    QNABOARD_REPLY_NICKNAME VARCHAR2(20) NOT NULL,
    QNABOARD_REPLY_DEPTH NUMBER(10,0) NOT NULL,
    QNABOARD_REPLY_GROUP NUMBER(10,0) NOT NULL
);
 
 


CREATE SEQUENCE GRADE_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE MEMBER_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE CATEGORY_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE COMPANY_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE PRODUCT_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE CART_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE ORDERS_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE ORDERSDETAIL_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE BOARDTYPE_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE BOARD_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE BOARDREPLY_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE QNABOARD_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;

CREATE SEQUENCE QNABOARDREPLY_SEQ_NO
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
NOCACHE
NOCYCLE;





-- Desc

DESC GRADE;
DESC MEMBER;
DESC CATEGORY;
DESC COMPANY;
DESC PRODUCT;
DESC CART;
DESC ORDERS;
DESC ORDERSDETAIL;
DESC BOARDTYPE;
DESC BOARD;
DESC BOARDREPLY;
DESC QNABOARD;
DESC QNABOARDREPLY;

-- Find Constraint SQL Query : SELECT * FROM USER_CONSTRAINTS;





----------------------- Real Data Insert ------------------------

-- GRADE --

Insert into ECOM.GRADE (GRADE_NO,GRADE_NAME) values (0,'MASTER');
Insert into ECOM.GRADE (GRADE_NO,GRADE_NAME) values (GRADE_SEQ_NO.NEXTVAL,'MEMBER');
Insert into ECOM.GRADE (GRADE_NO,GRADE_NAME) values (GRADE_SEQ_NO.NEXTVAL,'OUT');


-- CATEGORY --

Insert into ECOM.CATEGORY (CATEGORY_NO,CATEGORY_NAME) values (CATEGORY_SEQ_NO.NEXTVAL,'CPU');
Insert into ECOM.CATEGORY (CATEGORY_NO,CATEGORY_NAME) values (CATEGORY_SEQ_NO.NEXTVAL,'RAM');
Insert into ECOM.CATEGORY (CATEGORY_NO,CATEGORY_NAME) values (CATEGORY_SEQ_NO.NEXTVAL,'메인보드');
Insert into ECOM.CATEGORY (CATEGORY_NO,CATEGORY_NAME) values (CATEGORY_SEQ_NO.NEXTVAL,'하드디스크');

-- COMPANY --

Insert into ECOM.COMPANY (COMPANY_NO,COMPANY_NAME) values (COMPANY_SEQ_NO.NEXTVAL,'삼성');
Insert into ECOM.COMPANY (COMPANY_NO,COMPANY_NAME) values (COMPANY_SEQ_NO.NEXTVAL,'LG');
Insert into ECOM.COMPANY (COMPANY_NO,COMPANY_NAME) values (COMPANY_SEQ_NO.NEXTVAL,'Apple');
Insert into ECOM.COMPANY (COMPANY_NO,COMPANY_NAME) values (COMPANY_SEQ_NO.NEXTVAL,'ASUS');

-- BOARDTYPE --

Insert into ECOM.BOARDTYPE (BTYPE_NO,BTYPE_NAME) values (BOARDTYPE_SEQ_NO.NEXTVAL,'자유');
Insert into ECOM.BOARDTYPE (BTYPE_NO,BTYPE_NAME) values (BOARDTYPE_SEQ_NO.NEXTVAL,'질문');

-- MEBER --

Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'master','master','master',to_date('87/07/27','RR/MM/DD'),'135-748','서울 강남구 역삼1동  여삼빌딩 ','15층','010-1234-4567',null,1,null,'자기소개');
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'test','test','test',to_date('53/04/03','RR/MM/DD'),'449-722','경기 용인시 처인구 역북동  역북마을보성아파트 ','test',null,null,2,null,null);
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'ss','1234','ssss',to_date('52/03/06','RR/MM/DD'),'135-080','서울 강남구 역삼동   ','12-123','010','sdf@naver.com',2,'sd','sd');
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'tester','tester','tester',to_date('51/01/04','RR/MM/DD'),'135-532','서울 강남구 도곡2동  삼성타워팰리스 (B동)','tester',null,null,2,null,'내소개');
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'yeonhee521','dusgml430','김연희',to_date('89/04/30','RR/MM/DD'),'131-758','서울 중랑구 면목본동  아남리치카운티아파트 (101∼105동)','101동 202호',null,null,2,null,null);
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'asd','asd','www',to_date('27/01/22','RR/MM/DD'),'456-789','서울 강동구 구리구리 ','100층','010-124-2347','we@naver.com',2,'s23sd','gd');
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'aaa','aaa','rla',to_date('34/11/02','RR/MM/DD'),'216-623','서울 강북구 요리저리 ','지하10층','010-634-3447','kkkkk@naver.com',2,'comon','yo');
Insert into ECOM.MEMBER (MEMBER_NO,MEMBER_ID,MEMBER_PASSWORD,MEMBER_NAME,MEMBER_BIRTH,MEMBER_ZIP,MEMBER_ADDR1,MEMBER_ADDR2,MEMBER_PHONE,MEMBER_EMAIL,MEMBER_GRADE,MEMBER_NICKNAME,MEMBER_STATUS) values (MEMBER_SEQ_NO.NEXTVAL,'tester2','tester2','tester2',to_date('51/03/03','RR/MM/DD'),'135-536','서울 강남구 도곡2동  삼성타워팰리스 (F동)','타워팰리스 갑부','0000000','haha@email.com',2,'신신','애애');

-- PRODUCT --

Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'매직스테이션',699000,0,1,'인텔 / 펜티엄 / G3220 (3.0GHz) / 듀얼(2)코어 / 2GB / 500 GB / (인텔) HD 그래픽스 / DVD 레코더 / 슬림 / 윈도7 홈 프리미엄 / DVI / 멀티 리더기 / D-Sub / USB 3.0 / 모니터 미포함',7,'desktop1.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'인텔 코어i3',299000,1,0,'인텔(소켓1150) / 듀얼 코어 / 쓰레드 4개 / 64비트 / 3.5GHz / 256KB / 인텔 HD 4400 / 1,150MHz',10,'1_1.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASRock 970',329000,3,0,'AMD(소켓AM3+) / (AMD) 970 / 일반-ATX / DDR3 / CrossFire X / PCI-Express 16x / 8ch / 칩셋 AMD SB950 / 최대메모리 32GB / SATA 6Gbps 6개 / USB3.0 2개 / PS2 키보드,마우스 / 전원부 4+1페이즈',20,'2_1.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'GIGABYTE GA',899000,3,0,'인텔(소켓1150) / (인텔) B85 / Micro-ATX(22.6 x 19.3cm) / DDR3 / PCI-Express 3.0 x16 / 7.1ch / D-SUB / DVI / HDMI / USB 3.0 전면 헤더 포트 지원 / WINDOWS XP 지원 안함 / 최대메모리 32GB / SATA 6Gbps 4개/ SATA 2개 / USB 3.0 2개 / PS2 콤보 1개 / CPU 전원부 4페이즈',6,'asrock.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS A55BM-K iBORA',255000,3,0,'AMD(소켓FM2+) / (AMD) A55 / Micro-ATX(22.6 x 18.3cm) / DDR3 / PCI-Express 3.0 x16 / 8ch / D-SUB / DVI / 최대메모리 32GB / SATA 4개 / PS2 키보드,마우스 2개',200,'asus.jpg','dd',null,'tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'MacbookPro',1500000,0,3,'인텔 / 코어i5-4세대 / i5-4258U (2.4GHz) / LED백라이트 / 베젤없음 / 광시야각 / 33.78cm(13.3인치) / 2560x1600 / 256GB (SSD) / 8GB / DDR3L / ODD 옵션(선택사항) / Mac OS X Mavericks / 인텔 / Iris 5100 / 시스템메모리공유 / 1.57Kg / 리튬 폴리머 / 탈착 불가능 / 802.11 n/ac 무선랜 / 블루투스 4.0 / HDMI / 웹캠 / USB 2.0 / USB 3.0 / 썬더볼트 / 멀티 리더기 / 블록 키보드 / 키보드 라이트 / 14년형 하스웰 레티나 맥북프로',200,'/apple/macPro.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'MacAir',1100000,0,3,'인텔 / 코어i5-4세대 / i5-4260U (1.4GHz) / LED백라이트 / 베젤없음 / 33.78cm(13.3인치) / 1440x900 / 128GB (SSD) / 4GB / LPDDR3 / ODD 옵션(선택사항) / Mac OS X / 인텔 / HD 5000 / 시스템메모리공유 / 1.35Kg / 리튬 폴리머 / 탈착 불가능 / 802.11 n/ac 무선랜 / 블루투스 4.0 / 웹캠 / USB 2.0 / USB 3.0 / 썬더볼트 / 멀티 리더기 / 블록 키보드 / 키보드 라이트 / 2014년형',100,'/apple/macbookair.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'iMac',2100000,0,3,'인텔 / 코어i5-4세대 / 쿼드(4)코어 / 8GB / 1 TB / (엔비디아) 지포스 GT 755M / 일체형 / Mac OS / IEEE1394 / 멀티 리더기 / LED 백라이트 / 웹캠 / 68cm(27형)',400,'/apple/mac.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'MacMini',780000,0,3,'인텔 / 코어i5-3세대 / 듀얼(2)코어 / 4GB / 500GB / (인텔) HD 그래픽스 4000 / 컴팩트 / Mac OS X Lion / HDMI / IEEE1394 / 멀티 리더기 / 모니터 미포함',24,'/apple/miniMac.jpg','dd','ee','tt',null,'qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'아티브원',980000,0,0,'AMD / APU A / A6-5200 (2.0Ghz) / 쿼드(4)코어 / 4GB / 500GB / (AMD) 라데온 HD 8400 / 일체형 / 윈도8 / HDMI / 멀티 리더기 / LED 백라이트 / 웹캠 / 56cm(22형) / 블루투스 4.0',25,'/samsung/s3.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS N5',768000,0,4,'인텔 / 코어i7-3세대 / i7-3770 (3.4GHz) / 쿼드(4)코어 / 8GB / 2TB / (엔비디아) 지포스 GT 730M / 일체형 / DVD 레코더 / 윈도8 / 멀티 리더기 /',50,'/asus/asus1.jpg','/images/product-details/product1.jpg','/images/product-details/product2.jpg','/images/product-details/product3.jpg','/images/product-details/product4.jpg','/images/product-details/product5.jpg','/images/product-details/product6.jpg','/images/product-details/product7.jpg','/images/product-details/product8.jpg','/images/product-details/product9.jpg');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS S4',845000,0,4,'인텔 / 펜티엄 / G2020 (2.9GHz) / 듀얼(2)코어 / 4GB / 500GB / (인텔) HD 그래픽스 2500 / DVD 레코더 / 미들타워 / HDMI / 멀티 리더기',50,'/asus/asus2.jpg','/images/product-details/product1.jpg','/images/product-details/product2.jpg','/images/product-details/product3.jpg','/images/product-details/product4.jpg','/images/product-details/product5.jpg','/images/product-details/product6.jpg','/images/product-details/product7.jpg','/images/product-details/product8.jpg','/images/product-details/product9.jpg');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS T6',657000,0,4,'인텔 / 셀러론 / 1007U (1.5Ghz) / 듀얼(2)코어 / 2GB / 500GB / (인텔) HD 그래픽스 / 미니PC / 운영체제 미포함 / HDMI / 멀티 리더기 / 베사홀 / 광출력 / D-Sub / USB 3.0 / 무선랜 802.11ac 지원',50,'/asus/asus3.jpg','/images/product-details/product1.jpg','/images/product-details/product2.jpg','/images/product-details/product3.jpg','/images/product-details/product4.jpg','/images/product-details/product5.jpg','/images/product-details/product6.jpg','/images/product-details/product7.jpg','/images/product-details/product8.jpg','/images/product-details/product9.jpg');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'Samsung T4',789000,0,1,'인텔 / 펜티엄 / G3220 (3.0GHz) / 듀얼(2)코어 / 2GB / 500 GB / (인텔) HD 그래픽스 / DVD 레코더 / 슬림 / 윈도7 홈 프리미엄 / DVI / 멀티 리더기 / D-Sub / USB 3.0 / 모니터 미포함',20,'/samsung/s2.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'LG G4',712000,0,2,'인텔 / 셀러론 / N2920 (1.86GHz) / 쿼드(4)코어 / 4GB / 500 GB / (인텔) HD 그래픽스 / 일체형 / 운영체제 미포함 / 멀티 리더기 / USB 3.0 / LED 백라이트 / 웹캠 / 56cm(22형) / 블루투스 4.0 / 광시야각 패널',50,'/LG/lg3.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'LG T-34',980000,0,2,'인텔 / 코어i3-4세대 / i3-4130 (3.4GHz) / 듀얼(2)코어 / 4GB / 500GB / (인텔) HD 그래픽스 4400 / DVD 레코더 / 슬림 / 윈도7 홈 프리미엄 / DVI / 멀티 리더기 / D-Sub / USB 3.0',50,'/LG/lg2.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'LG vision5',690000,0,2,'인텔 / 코어i3-3세대 / i3-3120M (2.5GHz) / 듀얼(2)코어 / 4GB / 750GB / (인텔) HD 그래픽스 4000 / DVD 레코더 / 일체형 / 윈도8 / HDMI / 멀티 리더기 / 리모트 컨트롤 / HDTV 수신 / LED 백라이트 / 웹캠 /',50,'/LG/lg1.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS M56',780000,0,4,'인텔 / 코어i3-3세대 / i3-3217U (1.8Ghz) / 듀얼(2)코어 / 4GB / 500GB / (인텔) HD 그래픽스 4000 / 미니PC / 운영체제 미포함 / HDMI / 멀티 리더기 / 베사홀 / 광출력 / D-Sub / USB 3.0 / 무선랜 802.11ac 지원',50,'/asus/asus4.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'SAMSUNG-UT',990000,0,1,'인텔 / 펜티엄 / G2020 (2.9GHz) / 듀얼(2)코어 / 2GB / 500GB / (인텔) HD 그래픽스 / DVD 레코더 / 슬림 / 윈도7 홈 프리미엄 / 멀티 리더기 / 모니터 미포함',50,'/samsung/s1.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'AMD FX',260000,1,0,'AMD(소켓AM3+) / 64(32)비트 / 옥타(8) 코어 / 쓰레드 8개 / 3.3GHz / 2MB x4',50,'/cpu/amd1.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'WD 4TB GREEN',165200,4,0,'HDD (PC용) / SATA3(6Gb/s) / 4TB / 메모리 64MB / 8.9cm (3.5형) / 680g',50,'/HDD/hdd1.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'G.SKILL DDR3 8G',87000,2,0,'G.SKILL DDR3 8G PC3-12800 CL10 RIPJAWS XL (8Gx1) 티뮤정품',50,'/ram/r2.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'삼성 DDR3 4G PC3',38000,2,0,'DDR3 / PC용 / 1ea / 미포함 / Dimm / 4GB / 1,600MHz / 메모리 타이밍 : 11-11-11-30 / 동작전압 1.50V',50,'/ram/r3.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'AVEXIR DDR3 8G',115600,2,0,'DDR3 / PC용 / 2ea / 포함 / Dimm / 8GB / 1,600MHz / XMP / LED 라이트 / 메모리 타이밍 : 9-9-9-24 / 동작전압 1.50V',50,'/ram/r1.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'Seagate 1TB ',100000,4,0,'HDD (PC용) / SATA3(6Gb/s) / 1TB / 메모리 64MB / 8.9cm (3.5형) / SSD 8GB(MLC) 포함 / 400g',50,'/HDD/hdd2.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'Hitachi HGST 4TB',234000,4,0,'HDD (PC용) / SATA3(6Gb/s) / 4TB / 7,200RPM / 메모리 64MB / 8.9cm (3.5형) / 무상 3년 / RV센서장착',50,'/HDD/hdd3.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'AMD Athlon',240000,1,0,'AMD(소켓FM2+) / 쿼드 코어 / 쓰레드 4개 / 64(32)비트 / 3.4GHz / 2MB x2 / AMD R7 시리즈 / 720MHz',50,'/cpu/amd2.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'인텔 코어i5',399000,1,0,'인텔(소켓1150) / 쿼드 코어 / 쓰레드 4개 / 64비트 / 3.5GHz / 256KB / 인텔 HD 4600 / 1,200MH',9,'i5.jpg','dd','ee','tt','uu','qq','ㅐㅐ','vv','kk','ll');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'LG-TR5',876000,0,2,'인텔 / 코어i3-4세대 / i3-4130 (3.4GHz) / 듀얼(2)코어 / 8GB / 1 TB / (엔비디아) 지포스 GT 625 / DVD 레코더 / 슬림 / 윈도8.1 / HDMI / DVI / 멀티 리더기 / D-Sub / 모니터 미포함 / M-DISC 지원',50,'/LG/lg4.jpg','/images/product-details/product1.jpg','/images/product-details/product2.jpg','/images/product-details/product3.jpg','/images/product-details/product4.jpg','/images/product-details/product5.jpg','/images/product-details/product6.jpg','/images/product-details/product7.jpg','/images/product-details/product8.jpg','/images/product-details/product9.jpg');
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'삼성 아티브북',1119000,0,1,'인텔 / 코어i5-4세대 / i5-4200U (1.6GHz) / LED백라이트 / 눈부심방지 / 밝기자동조절 / 33.78cm(13.3인치) / 1920x1080 / 128GB (SSD) / 8GB / DDR3L / ODD 옵션(선택사항) / 윈도8.1 / 인텔 / HD 4400 / 시스템 메모리 공유 / 1.16Kg / 탈착 불가능 / 4cell / 1Gbps 유선랜 / 802.11 a/b/g/n 무선랜 / 블루투스 4.0 / HDMI / D-SUB / 웹캠 / USB 2.0 / USB 3.0 / 멀티 리더기 / 블록 키보드 / 키보드 라이트 / 색상: 블랙 / 기가비트 이더넷',50,'/samsung/s4.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'삼성 9 Style',949000,0,1,'인텔 / 코어i3-4세대 / i3-4010U (1.7GHz) / LED백라이트 / 눈부심방지 / 광시야각 / 39.62cm(15.6인치) / 1920x1080 / 128GB (SSD) / 4GB / DDR3L / ODD 옵션(선택사항) / 윈도8.1 / 인텔 / HD 4400 / 시스템 메모리 공유 / 1.95Kg / 4cell / 1Gbps 유선랜 / 802.11 n/ac 무선랜 / WiDi / 블루투스 4.0 / HDMI / D-SUB / 웹캠 / USB 2.0 / USB 3.0 / 멀티 리더기 / 블록 키보드 / 색상: 화이트 / VGA 어댑터 필요',50,'/samsung/s5.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'삼성 아티브탭5',813000,0,1,'인텔 / 아톰 / Z2760 (1.8GHz) / LED백라이트 / 터치스크린 / 29.46cm(11.6인치) / 1366x768 / 128GB (eMMC) / 2GB / LPDDR2 / 윈도8 / 인텔 / SGX545 / 시스템메모리공유 / 757g / 탈착 불가능 / 2cell / 802.11 b/g/n 무선랜 / 블루투스 4.0 / HDMI / USB 2.0 / 멀티 리더기 / (전면) 200만 화소 웹캠, (후면) 800만 화소 웹캠 / 조도센서 / 가속센서 / 방향센서 / 중력센서 / GPS / 근거리 통신(NFC) / S펜 / 색상: 화이트 ',50,'/samsung/s6.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'LG전자 15ND530',508000,0,2,'인텔 / 코어i3-4세대 / i3-4000M (2.4GHz) / LED백라이트 / 39.62cm(15.6인치) / 1366x768 / 500GB / 4GB / DDR3L / DVD레코더 / 운영체제 미포함 / 인텔 / HD 4600 / 시스템메모리공유 / 2.35Kg / 4cell / 1Gbps 유선랜 / 802.11 n/ac 무선랜 / WiDi / 블루투스 4.0 / HDMI / D-SUB / 웹캠 / USB 2.0 / USB 3.0 / 멀티 리더기 / 숫자 키패드 / 블록 키보드',50,'/LG/lg5.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'LG전자 그램',1375000,0,2,'인텔 / 코어i7-4세대 / i7-4500U (1.8GHz) / LED백라이트 / 광시야각 / 33.78cm(13.3인치) / 1920x1080 / 256GB (SSD) / 8GB / DDR3L / ODD 옵션(선택사항) / 운영체제 미포함 / 인텔 / HD 4400 / 시스템 메모리 공유 / 980g / 리튬 폴리머 / 탈착 불가능 / 100Mbps 유선랜 / 802.11 n/ac 무선랜 / WiDi / 블루투스 4.0 / HDMI / 웹캠 / USB 2.0 / USB 3.0 / 멀티 리더기 / 블록 키보드 / 색상: 블랙',50,'/LG/lg6.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'APPLE 애플TV ',69890,0,3,'셋톱박스 / 거치형 / 풀HD / 스마트기능 / 양방향서비스 / USB / LAN / HDMI / 옵티컬 / 아이폰, 아이패드, 아이팟 터치와 완벽 호환 (리모컨 기능, 기기 내 영화감상) / 100% 스트리밍 지원 서비스 / 넷플릭스, 유튜브, MobileMe, 플리커 지원 / 5.1ch 사운드 지원 / 소비전력:6W',50,'/apple/appleTV.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'APPLE iPod Touch ',243810,0,3,'MP3 / 10.2cm / 16GB저장 / E-BOOK / 블루투스 / WiFi / 내장스피커 / EarPods / 색상: 실버 / Retina 디스플레이 / iOS6',50,'/apple/ipod.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS 트랜스포머',436000,0,4,'인텔 / 아톰 / Z3740 (1.33GHz) / LED백라이트 / 터치스크린 / 광시야각 / 25.65cm(10.1인치) / 1366x768 / 64GB (eMMC) / 2GB / LPDDR3 / ODD 옵션(선택사항) / 윈도8.1 / 인텔 / HD Graphics / 시스템메모리공유 / (태블릿) 540g, (키보드포함) 1.03Kg / 2cell / 802.11 b/g/n 무선랜 / 블루투스 4.0 / HDMI / 웹캠 / USB 2.0 / USB 3.0 / 멀티 리더기 ',50,'/asus/asus5.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS X451C',369000,0,4,'인텔 / 펜티엄 / 2117U (1.8GHz) / LED백라이트 / 35.56cm(14인치) / 1366x768 / 500GB / 4GB / DDR3 / ODD 옵션(선택사항) / 운영체제 미포함 / 인텔 / HD Graphics / 시스템메모리공유 / 1.92Kg / 4cell / 100Mbps 유선랜 / 802.11 b/g/n 무선랜 / 블루투스 4.0 / HDMI / D-SUB / 웹캠 / USB 2.0 / USB 3.0 / 멀티 리더기 / 블록 키보드',50,'/asus/asus6.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'AMD FX 8300',130700,1,0,'AMD(소켓AM3+) / 64(32)비트 / 옥타(8) 코어 / 쓰레드 8개 / 3.3GHz / 2MB x4',50,'/cpu/amd4.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'인텔 G3258',80200,1,0,'인텔(소켓1150) / 듀얼 코어 / 쓰레드 2개 / 64비트 / 3.2GHz / 256KB / 인텔 HD / 1,100MHz',50,'/cpu/intel3.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'G.SKILL DDR3 32G',562900,2,0,'DDR3 / PC용 / 4ea / 포함 / Dimm / 32GB / 2,666MHz / XMP',50,'/ram/r4.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'G.SKILL DDR3 8G',104000,2,0,'DDR3 / PC용 / 2ea / 포함 / Dimm / 8GB / 2,400MHz / XMP ',50,'/ram/r5.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'CORSAIR DDR3 4G',31300,2,0,'DDR3 / PC용 / 1ea / 포함 / Dimm / 4GB / 1,333MHz / XMP ',50,'/ram/r6.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASRock H97',123200,3,0,'인텔(소켓1150) / (인텔) H97 / 일반-ATX(30.5 x 24.4cm) / DDR3 / CrossFire X / PCI-Express 3.0 x16 / 7.1ch / D-SUB / DVI / HDMI / USB 3.0 전면 헤더 포트 지원 / WINDOWS XP 지원 안함 / 최대메모리 32GB / SATA 6Gbps 6개 / USB 3.0 4개 / PS2 콤보포트 1개 / CPU 전원부 8페이즈',50,'/mainBoard/m1.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASUS Z97-DELUXE',389000,3,0,'인텔(소켓1150) / (인텔) Z97 / 일반-ATX(30.5 x 24.4cm) / DDR3 / CrossFire X / SLI / PCI-Express 3.0 x16 / 8ch / D-SUB / DVI / HDMI / DisplayPort / USB 3.0 전면 헤더 포트 지원 / WINDOWS XP 지원 안함 ',50,'/mainBoard/m2.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'ASRock H97M',128200,3,0,'인텔(소켓1150) / (인텔) H97 / Mini-iTX(17.0 x 17.0cm) / DDR3 / PCI-Express 3.0 x16 / 7.1ch / D-SUB / DVI / HDMI / USB 3.0 전면 헤더 포트 지원',50,'/mainBoard/m3.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'Seagate 500GB',49500,4,0,'HDD (PC용) / SATA3(6Gb/s) / 500GB / 7,200RPM / 메모리 16MB / 8.9cm (3.5형) / 무상 2년',50,'/HDD/hdd4.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'Seagate 2TB',105000,4,0,'HDD (PC용) / SATA3(6Gb/s) / 2TB 이상 / 5,900RPM / 메모리 64MB / 8.9cm (3.5형)',50,'/HDD/hdd5.jpg',null,null,null,null,null,null,null,null,null);
Insert into ECOM.PRODUCT (PRODUCT_NO,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_CATEGORY,PRODUCT_COMPANY,PRODUCT_DETAIL,PRODUCT_COUNT,PRODUCT_IMAGE0,PRODUCT_IMAGE1,PRODUCT_IMAGE2,PRODUCT_IMAGE3,PRODUCT_IMAGE4,PRODUCT_IMAGE5,PRODUCT_IMAGE6,PRODUCT_IMAGE7,PRODUCT_IMAGE8,PRODUCT_IMAGE9) values (PRODUCT_SEQ_NO.NEXTVAL,'Seagate 750GB',130000,4,0,'HDD (노트북용) / SATA3(6Gb/s) / 750GB / 7,200RPM / 메모리 32MB / 6.4cm (2.5형) / SSD 8GB(SLC) 포함',50,'/HDD/hdd6.jpg',null,null,null,null,null,null,null,null,null);

COMMIT;

